MySQL / Function
-
Show each employees employee_id, first_name and his salary in - 10 thousands 5 hundreds and 12 taka only format
-
For each jobs, show the job_id, job_title and how much greater the max_salary then min_salary in percentage
-
Show each employees employee_id, and yearly total salary with commission he receives
-
Show each employees email, hire_date in January 4th, 1987 format
-
Show each employees email, hire_date in Jan 1987, 04 format
-
Show each employees email, hire_date in 1st Aug, 87 05:10 PM format
-
Show each employees email, hire_date in 15 Jan, 2019 Tuesday 14:10 format
-
Show those employees first_name, email, phone_number, address who is hired after the date 05 May, 1987 00:00 AM
-
Show those employees first_name, email, phone_number, address details who is hired before the date 1st June 1987 12:01 PM
-
Show each employees employee_id and his total current experience(upto present date) in number of years format
-
Show each employees employee_id, email and his total current experience in 10 years, 6 months and 15 days format
-
Show those employee_id s from the job_history table whose total experience is greater than 5 years
-
For each job_history, show how many days an employee have served during his last month of retirement
-
Show how many days an employee have served during his first month of joining
-
Show those employees details who have been hired in the leap day(19th Feb) of any leap year
-
Show those employees details whose hiring month is either 2 or 4 or 6 or 8
-
Show each employees first_name, department_id, manager_id and his modified join_date that is one week before the his real join_date
-
From the employees table, show each employees employee_id, join_date and estimated retirement date that is 30 years after his join_date
-
Show each employees short name that is first 3 letters from the first name followed by an underscore and then followed by the first 3 letters from last_name
-
Show those employees names that is a palindrome
-
Show each employees employee_id and email (join @gmail.com in each email)
-
Show each employees first_name and phone_number(format: 515.xxx.xxx7)
-
Show each employees employee_id, email and full_name (format: first_name<SPACE>last_name and right pad the string if total no of characters is less than 20)